{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Notes Balance","Cumulative Defaults","Collateral Tables"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":1,"defined_names":24,"comments":2,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Notes Balance","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[]}
["TOTAL NOTE BALANCES"]
[null,"Total Notes","Class A Notes","Class A2 Notes","Class B Notes","Class C Notes"]
["Initial Invested Amount",{"$f":"SUM(C3:G3)","v":492250000},492250000,0,0,0]
["Invested Amount as at Previous Payment Date:  7 June 2024",{"$f":"SUM(C4:G4)","v":492250000},492250000,0,0,0]
["Stated Amount as at Previous Payment Date:  7 June 2024",492250000,492250000,0,0,0]
["Principal Payments to Noteholders on Payment Date",35835628.18,35835628.18,0,0,0]
["Gross Aggregate Charge-Offs",0,0,0,0,0]
["Gross Aggregate Reinstatements of charge-offs",0,0,0,0,0]
["Aggregate Charge-Offs for this Collection Period",0,0,0,0,0]
["Reinstatements relating to Charge-offs that have occurred this Collection Period",{"$f":"SUM(C10:G10)","v":0},0,0,0,0]
["Aggregate Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Reinstatements of Carry Over Charge-offs not previously reinstated",0,0,0,0,0]
["Aggregate Charge-Offs not reinstated and to be carried over to next period",0,0,0,0,0]
["Invested Amount as at Payment Date:  16 August 2024",456414371.81999999,456414371.81999999,0,0,0]
["Stated Amount as at Payment Date:  16 August 2024",456414371.81999999,456414371.81999999,0,0,0]
["Bond Factor at Payment Date:  16 August 2024",null,0.92720034905027926,0,0,0]
["Coupon Margin",null,1.2500000000000001E-2,0,0,0]
["Coupon Rate (3 month BBSW + margin)",null,5.5665000000000006E-2,4.3165000000000002E-2,4.3165000000000002E-2,4.3165000000000002E-2]
["Days in Coupon Period",null,70,70,70,70]
["Coupon Entitlement to be paid out on the current Payment Date: 16 August 2024",null,5255004.76,0,0,0]

{"sheet":"Cumulative Defaults","index":1,"n_rows":4,"n_cols":4,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Cumulative Defaults & Losses"]
[]
["Month","Gross Losses","Recoveries","Net Losses"]
["2024-07-01",{"$f":"+'Collateral Tables'!E9/550000000","v":0},{"$f":"+'Collateral Tables'!E23/540000000","v":0},{"$f":"+B4-C4","v":0}]

{"sheet":"Collateral Tables","index":2,"n_rows":252,"n_cols":7,"rows_kept":252,"cut":false,"hidden":false,"merged":[]}
[null,"CNHI CAPITAL AUSTRALIA RECEIVABLES TRUST SERIES 2024-1 (TERM DEAL)"]
[null,"COLLATERAL DATA TABLES"]
[]
[null,"OUTSTANDING RECEIVABLES",null,null,"2024-07-31"]
[]
[null,"Opening Balance",null,null,549999988.53020084]
[null,"Principal Repayments - Scheduled",null,null,31195990.270000018]
[null,"Principal Repayments - Unscheduled",null,null,4639626.439999938]
[{"$f":"SUM(E9)","v":0},"Charge-Offs",null,null,0]
[null,"Reinstatements"]
[null,"New Receivables Purchased"]
[null,"Non Cash Change in Receivables"]
[null,"Closing Balance",null,null,514164371.82020086]
[]
[null,"PORTFOLIO STATISTICS"]
[]
[null,"Summary"]
[null,"Number of contracts",null,null,2855]
[null,"Dollar value of contracts",null,null,514164371.82019973]
[null,"Number of contracts closed during the Quarter",null,null,31]
[null,"Dollar value of contracts closed during the Quarter",null,null,5938251.540000001]
[]
[{"$f":"SUM(E23)","v":0},"Dollar Value of Recoveries from Collateral",null,null,0]
[{"$f":"SUM(E24)","v":0},"Dollar Value of Recoveries from Other Sources",null,null,0]
[]
[null,"Average Term of Contracts (Months)",null,null,52.110884622343292]
[null,"Average Term to Maturity (Months)",null,null,35.702660119862699]
[null,"Average Residual / Balloon Payment *",null,null,3.2549295692982184E-2]
[null,"Average Seasoning (Months)",null,null,16.408224502480593]
[null,"Average Dollar Value of Individual Assets",null,null,180092.59958675998]
[null,"Weighted Average Interest Rate",null,null,3.5238095408453109E-2]
[]
[null,"Payment in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,2851,133092.5,2.5885204672746495E-4]
["2. 31 - 60 Days","31 - 60 Days",null,null,1,3218.29,6.2592629446627963E-6]
["3. 61 - 90 Days","61 - 90 Days",null,null,0,0,0]
["4. 91 - 120 Days","91 - 120 Days",null,null,3,74438.329999999987,1.4477535605292901E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,0,0,0]
[null,"Total",null,null,2855,210749.12,4.0988666572505672E-4]
[null,"* Expressed as a % of Aggreg. Rec. closing bal.",null,null,null,"> 30 days",1.5103461899759179E-4]
[]
[" 0 - 30 Days","Account Balances in Arrears"]
["1. 0 - 30 Days","0 - 30 Days",null,null,2851,513670479.4701997,0.99903942712278659]
["2. 31 - 60 Days","31 - 60 Days",null,null,1,47827.9,9.3020642077326095E-5]
["3. 61 - 90 Days","61 - 90 Days",null,null,0,0,0]
["4. 91 - 120 Days","91 - 120 Days",null,null,3,446064.45000000007,8.6755223513617209E-4]
["5. 121 - 150 Days","121 - 150 Days",null,null,0,0,0]
["6. 151 - 180 Days","151 - 180 Days",null,null,0,0,0]
[null,"Total",null,null,2855,514164371.82019967,1]
["NSW",null,null,null,null,"> 30 days",9.6057287721349816E-4]
[null,null,null,null,null,"> 60 days",8.6755223513617209E-4]
[null,null,null,null,null,">90 days",8.6755223513617209E-4]
[]
["VIC","Geographic Distribution"]
["NSW","New South Wales",null,null,0.31945155225115002,164250606.6902006]
["VIC","Victoria",null,null,0.16593540086775035,85318071.149900064]
["QLD","Queensland",null,null,0.11317345961545641,58189760.769900009]
["SA","South Australia",null,null,0.14218605723553523,73107004.800100088]
["NT","Northern Territory",null,null,0,0]
["ACT","Australian Capital Territory",null,null,6.8792670279318514E-5,35370.740100000003]
["TAS","Tasmania",null,null,1.0872845526439804E-2,5590429.7900000019]
["WA","Western Australia",null,null,0.24831189183338873,127673127.87999997]
[null,"Total",null,null,1,514164371.8202008]
["AG",null,null,null,null,null,0]
["CE","Top Industry Distribution"]
["AGRICULTURAL MACHINERY","Agricultural",null,null,0.98446262038398558,506175604.79019958]
["CONSTRUCTION EQUIPMENT","Construction",null,null,1.5537379616014372E-2,7988767.030000004]
["MOTOR VEHICLE - AG","Motor Vehicle AG",null,null,0,0]
[null,"Total",null,null,1,514164371.82019961,1.1920928955078125E-6]
["COMBINE"]
["40-100 HP TRACTOR","Collateral Types"]
["100<140 HP TRACTOR","100<140 HP TRACTOR",null,null,7.5803604968236696E-2,38975512.930200018]
["4 EWD TRACTORS","4 EWD TRACTORS",null,null,6.0249801849033842E-2,30978301.520000014]
["40<60 HP TRACTOR","40<60 HP TRACTOR",null,null,5.2441550949059107E-3,2696357.7100999993]
["4WD Vehicle","4WD Vehicle",null,null,4.9325547626370182E-2,25361439.209999986]
["60<100 HP TRACTOR","60<100 HP TRACTOR",null,null,3.6818676355933874E-2,18930851.599799994]
["BACKHOE","BACKHOE",null,null,5.8074115276197556E-4,298596.41000000003]
["BALERS, WINDROWERS, MOWERS, RAKES","BALERS, WINDROWERS, MOWERS, RAKES",null,null,3.1258512726393795E-2,16072013.559999997]
["COMBINES","COMBINES",null,null,0.34566950358853599,177730943.17000002]
["COMPACT TRACK LOADER","COMPACT TRACK LOADER",null,null,3.4945792989101252E-3,1796788.1699999997]
["COMPACT WHEEL LOADER","COMPACT WHEEL LOADER",null,null,1.8254742091080165E-4,93859.37999999999]
["COTTON PICKERS","CRAWLER EXCAVATOR",null,null,2.464910891264925E-3,1267369.3599999996]
["CRAWLER EXCAVATOR","CRAWLER  DOZER",null,null,5.619759474525456E-4,288948.00999999989]
["CRAWLER  DOZER","CULTIVATORS,SEEDERS, HARROWS",null,null,5.0704324723449753E-2,26070357.269999985]
["CULTIVATORS,SEEDERS, HARROWS","DRILL",null,null,1.4294421595143383E-3,734968.23]
["DRILL","FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE",null,null,4.0337410246022781E-3,2074005.9200000004]
["DUMP TRUCKS","FRONT END LOADER",null,null,1.8532096586676896E-3,952854.38]
["EXCAVATORS / GRADERS","FRONTS",null,null,2.1212155563190095E-2,10906534.640099999]
["FEEDERS, MIXERS, WAGONS, BINS, FEED STORAGE","GRADER",null,null,1.3197167038195424E-3,678551.31]
["FRONT END LOADER","HARVESTERS - Other",null,null,1.0550030413030827E-2,5424449.7600000007]
["FRONTS","IRRIGATION EQUIPMENT",null,null,7.2612007066595488E-4,373345.07]
["GRADER","MATERIALS HANDLING EQUIPMENT",null,null,4.8780470554989612E-4,250811.80000000002]
["HARVESTERS - Other","MIDI CRAWLER EXCAVATOR",null,null,2.0856771856899578E-4,107238.09]
["IRRIGATION EQUIPMENT","MINI EXCAVATOR",null,null,6.2448883586255775E-4,321089.91000000003]
["MATERIALS HANDLING EQUIPMENT","Other - Medium",null,null,1.2224384740524073E-3,628534.3101]
["MIDI CRAWLER EXCAVATOR","OTHER AG",null,null,1.2740226198112948E-3,655057.04]
["MINI EXCAVATOR","OVER 140 HP TRACTOR",null,null,0.18599124612905146,95630072.229999959]
["OTHER AG","SKID STEER LOADER",null,null,3.1954448422469471E-3,1642983.89]
["OTHER CE","SPRAYING EQUIPMENT",null,null,7.7727567350729276E-2,39964745.840000011]
["OVER 140 HP TRACTOR","Sugar Cane Harvesters",null,null,6.7186046123164757E-3,3454467.1199999996]
["QUAD BIKES","Telehandlers",null,null,9.0918528124595797E-3,4674706.7899999991]
["ROLLER","TRAILER - on Farm",null,null,3.469866443067904E-4,178408.1700000001]
["SCRAPERS","Trailers",null,null,5.7695241883413909E-3,2966483.7800000012]
["SKID STEER LOADER","TRUCK - on Farm",null,null,7.2784236036266248E-4,374230.61000000004]
["SKIDSTEER / UNILOADER","UNDER 40 HP TRACTORS",null,null,3.7187705037420107E-4,191205.93]
["Soundproof Generators","WHEEL LOADERS",null,null,2.7584344183147068E-3,1418288.6999000004]
["SPRAYING EQUIPMENT","Total",null,null,0.99999999999999989,514164371.82020009,-4.76837158203125E-7]
["Sugar Cane Harvesters"]
["Telehandlers","Contract Balance Distribution"]
["TRAILER - on Farm","$ 0 - $25,000",null,null,0,""]
["TRUCK - on Farm","$ 25,001 to $50,000",null,null,3.7495502832782204E-2,19278851.660099994]
["UNDER 40 HP TRACTORS","$ 50,001 to $75,000",null,null,5.1223754043405442E-2,26337429.319999989]
["WHEEL LOADERS","$ 75,001 to $100,000",null,null,5.5766118485406753E-2,28672951.279900007]
["WHEEL LOADERS (OLD)","$100,001 to $125,000",null,null,5.8980370659958259E-2,30325605.230099995]
[null,"$125,001 to $150,000",null,null,5.6461204939831422E-2,29030339.970099997]
["$ 0 - $25,000","$150,000 to $200,000",null,null,7.6918433185078641E-2,39548717.879999988]
["$ 25,001 to $50,000","$200,001 to $300,000",null,null,0.16938090062851477,87089624.37000002]
["$0 - $25,000","$300,001 to $400,000",null,null,0.16699203182056566,85861353.140000001]
["$25,001 - $50,000","$400,001 to $500,000",null,null,0.12008122830725929,61741489.319999993]
["$50,001 - $75,000","$500,000+",null,null,0.20670045509719756,106278009.65000005]
["$75,001 - $100,000","Total",null,null,1,514164371.82020003,0]
["$100,001 - $125,000"]
["$125,001 - $150,000","Residual / Balloon Payment Distribution"]
["$150,001 - $200,000",0,null,null,0.88582547356951324,455459898.16019964]
["$200,001 - $300,000","0 to 5",null,null,0,""]
["$300,001 - $400,000","06 to 10",null,null,2.416057720223386E-4,124225.0800000001]
["$400,001 - $500,000","11 to 15",null,null,8.8526068305481535E-3,4551695.03]
["$500,001+","16 to 20",null,null,1.5724881347530126E-2,8085173.7400000021]
["$200,001 to $300,000","21 to 25",null,null,2.1029443544915823E-2,10812590.629999997]
["0","26 to 30",null,null,3.1458085403195099E-2,16174626.720000001]
["0 to 5","31 to 35",null,null,1.6764235315422083E-2,8619572.5200000014]
[0,"36 to 40",null,null,1.3180318574017854E-2,6776850.2199999997]
["0 to 5","41+%",null,null,6.9233496428352699E-3,3559739.72]
["6 to 10",null,null,null,0.99999999999999989,514164371.82019967,0]
["11 to 15"]
["16 to 20","Quarter of Maturity Distribution"]
["21 to 25","2024Q3",null,null,0,0]
["26 to 30","2024Q4",null,null,4.9036027352001507E-3,2521257.8199999998]
["31 to 35","2025Q1",null,null,4.4161770135135482E-3,2270640.8800000004]
["36 to 40","2025Q2",null,null,2.2540912469238257E-3,1158973.4100000001]
["41+ %","2025Q3",null,null,1.0162690583756066E-2,5225293.419999999]
[null,"2025Q4",null,null,1.3416444386411664E-2,6898257.700000002]
["2004 Q1","2026Q1",null,null,3.7596678493234607E-2,19330872.579999994]
["2004 Q2","2026Q2",null,null,2.6785862935707425E-2,13772336.389999986]
[{"$f":"RIGHT(B146,2)&LEFT(B146,4)","v":"Q32026"},"2026Q3",null,null,3.9025759912078906E-2,20065655.329999994]
["Q42026","2026Q4",null,null,4.2090844943974297E-2,21641612.849999983]
["Q12027","2027Q1",null,null,0.15325854316011575,78800082.569999918]
["Q22027","2027Q2",null,null,8.2112327037634172E-2,42219233.049999997]
["Q32027","2027Q3",null,null,9.1285640239602547E-2,46935823.870000012]
["Q42027","2027Q4",null,null,0.14823687701304422,76218120.750000119]
["Q12028","2028Q1",null,null,0.1482845665678709,76242641.019999966]
["Q22028","2028Q2",null,null,9.6463445346314555E-2,49598066.780100018]
["Q32028","2028Q3",null,null,4.7862958576806551E-2,24609428.030099992]
["Q42028","2028Q4",null,null,5.1843489807810811E-2,26656075.369999986]
[""]
["",null,null,null,1,514164371.82019997,0]
[""]
["onSeas","Seasoning Distribution"]
["hs0 to","0 to 6 months",null,null,1.0336125315696578E-2,5314467.38]
["hs07 t","07 to 12 months",null,null,0.24230710293860402,124585679.36999993]
["hs13 t","13 to 18 months",null,null,0.30770304377590169,158209942.21020004]
["hs19 t","19 to 24 months",null,null,0.43709467049301848,224738506.68000025]
["hs25 t","25 to 30 months",null,null,2.5590574767792697E-3,1315776.1799999997]
["hs31 t","31 to 36 months",null,null,0,0]
["hs37 t","37 to 42 months",null,null,0,0]
["Q42025","43 to 48 months",null,null,0,0]
["Q12026","49 to 54 months",null,null,0,0]
["Q22026","55 to 60 months",null,null,0,0]
["Q32026","61 to 72 months",null,null,0,0]
["Q42026","Total",null,null,1,514164371.8202002,0]
["Q12027"]
[null,"Remaining Term Distribution"]
[null,"0-12 Months",null,null,1.7282159766424495E-2,8885870.8200000003]
["0 to 6 months","13-24 Months",null,null,0.10855700332250665,55816143.420000091]
["07 to 12 months","25-36 Months",null,null,0.33526913169759942,172383442.49000043]
["0 to 6 months","37-48 Months",null,null,0.47323947061677862,243322875.13020042]
["07 to 12 months","49-60 Months",null,null,6.5652234596690798E-2,33756039.959999986]
["13 to 18 months","60+ Months",null,null,0,0]
["19 to 24 months",null,null,null,1,514164371.82020092,-7.152557373046875E-7]
["25 to 30 months"]
["31 to 36 months","Origination LVR Distribution"]
["37 to 42 months","10% to 20%",null,null,3.2018171429732707E-4,164626.03000000003]
["43 to 48 months","21% to 30%",null,null,6.8623168647590415E-3,3528358.8399999994]
["49 to 54 months","31% to 40%",null,null,3.0452420992474631E-2,15657549.91]
["55 to 60 months","41% to 50%",null,null,8.3354220204676241E-2,42857770.270100012]
["60+ months","51% to 60%",null,null,0.11386750068414563,58546611.959999964]
["61 to 72 months","61% to 70%",null,null,0.16914440333977901,86968025.890100062]
[null,"71% to 80%",null,null,0.1870000531729227,96148764.869999856]
[null,"81% to 90%",null,null,0.19961572282139947,102635292.72990009]
["0 - 12 months","91% to 100%",null,null,0.2093831802055455,107657371.3201001]
["13 - 24 months","> 100%",null,null,0,0]
["25 - 36 months",null,null,null,0.99999999999999956,514164371.82020009,8.3446502685546875E-7]
["37 - 48 months"]
["49 - 60 months","New v Used"]
["60+ Months","New",null,null,0.89599198221244969,460687154.69020027]
[null,"Used",null,null,0.10400801778755039,53477217.13000007]
[]
[null,null,null,null,1,514164371.82020032,0]
["01. 10% to 20%"]
["02. 21% to 30%","Contract Type"]
["03. 31% to 40%","Finance Lease",null,null,0,0]
["04. 41% to 50%","Goods Mortgage",null,null,1,514164371.82019973]
["05. 51% to 60%",null,null,null,1,514164371.82019973,5.9604644775390625E-7]
["06. 61% to 70%"]
["07. 71% to 80%","Contract by Source"]
["08. 81% to 90%","Non Hardship Refinance",null,null,1,514164371.8202002]
["09. 91% to 100%","Hardship Refinance",null,null,0,0]
["> 100%",null,null,null,1,514164371.8202002,-4.76837158203125E-7]
[]
[null,"Payment Frequency Distribution"]
[null,"6 Consecutive",null,null,7.6787857859988932E-3,3948158.07]
["New","Annual",null,null,0.7053161043546905,362648411.73019993]
["USed","Monthly",null,null,0.20094288197029994,103317670.67999981]
["Used","Quarterly",null,null,1.867234940066461E-2,9600656.8000000026]
[null,"Semi-Annual",null,null,5.0375327151328753E-2,25901198.440000001]
[null,"Structured",null,null,1.7014551337017229E-2,8748276.1000000034]
[null,null,null,null,1,514164371.82019979,0]
["Finance Lease"]
["Goods Mortgage","Yield Distribution"]
["Hire Purchase",null,null,null,7.3506433431401716E-2,37794389.170000002]
[null,null,null,null,0.16442068325508721,84539257.32009998]
[null,null,null,null,0.21967481822971874,112948964.91979994]
[null,null,null,null,0.20110315112665642,103400075.37010002]
["Non Hardship Refinance","< 4%",null,null,0.65870508604286404,338682686.77999997]
["Refinance - Hardship","4% to 5%",null,null,0.11557710698570291,59425630.610099971]
[null,"5% to 6%",null,null,0.14390159451941475,73989072.950000003]
[null,"6% to 7%",null,null,6.0071875985411353E-2,30886818.380099982]
[null,"7% to 8%",null,null,1.7240491943498255E-2,8864446.7099999972]
["6 Consecutive","8% to 9%",null,null,4.5038445231086388E-3,2315716.3900000011]
["Annual","9% to 10%",null,null,0,0]
["Monthly",null,null,null,0.99999999999999989,514164371.82019991,0]
["Quarterly"]
["Semi Annual","Top 5 Obligor",null,null,3.6633378161384254E-2,18835577.870000001]
["Structured"]
["0% to 1%"]
["1.01% to 2%"]
["2.01% to 3%"]
["01. 0% to 1%"]
["02. 1.01% to 2%"]
["03. 2.01% to 3%"]
["04. 3.01% to 4%"]
[]
["05. 4.01% to 5%"]
["06. 5.01% to 6%"]
["07. 6.01% to 7%"]
["08. 7.01% to 8%"]
["09. 8.01% to 9%"]
["10. 9.01% to 10%"]
["11. 10.01% to 11%"]
["12. 11.01% to 12%"]
["13. > 12%"]